Re: Question on locking - Mailing list pgsql-novice

From M. Bastin
Subject Re: Question on locking
Date
Msg-id a06110408bdb12fcf4347@[192.168.0.116]
Whole thread Raw
In response to Question on locking  (Steve Tucknott <steve@retsol.co.uk>)
List pgsql-novice
Retraction of the previous (I realize SELECT FOR UPDATE can be useful
with Tom's method)

>Note: after thinking a little about it there's no need to use SELECT
>FOR UPDATE with Tom's method.  A regular UPDATE will do (it does its
>own locking all by itself for only the time needed).
>
>(Therefore, if Tom's method would be the only recommendable one, the
>command SELECT FOR UPDATE would be without purpose.  From this again
>I deduce that it originally must have been meant for use in long
>lasting transactions.)

pgsql-novice by date:

Previous
From: "M. Bastin"
Date:
Subject: Re: Question on locking
Next
From: Frank Bax
Date:
Subject: Re: Install 7.4.6 on Redhat 8.0 - Any issues?